/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50737
 Source Host           : localhost:3306
 Source Schema         : ssm_song_edu

 Target Server Type    : MySQL
 Target Server Version : 50737
 File Encoding         : 65001

 Date: 22/05/2022 16:10:31
*/
CREATE DATABASE `ssm_song_edu` ;

USE `ssm_song_edu`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `course_name` varchar(255) DEFAULT NULL COMMENT '课程名',
  `brief` varchar(255) DEFAULT '' COMMENT '课程一句话简介',
  `price` double(10,2) DEFAULT NULL COMMENT '原价',
  `price_tag` varchar(255) DEFAULT '' COMMENT '原价标签',
  `discounts` double(10,2) DEFAULT NULL COMMENT '优惠价',
  `discounts_tag` varchar(255) DEFAULT NULL COMMENT '优惠标签',
  `course_description_mark_down` longtext COMMENT '描述markdown',
  `course_description` longtext COMMENT '课程描述',
  `course_img_url` varchar(255) DEFAULT NULL COMMENT '课程分享图片url',
  `is_new` tinyint(1) DEFAULT NULL COMMENT '是否新品',
  `is_new_des` varchar(255) DEFAULT NULL COMMENT '广告语',
  `last_operator_id` int(11) DEFAULT NULL COMMENT '最后操作者',
  `auto_online_time` datetime DEFAULT NULL COMMENT '自动上架时间',
  `create_time` datetime NOT NULL COMMENT '记录创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `total_duration` int(11) DEFAULT NULL COMMENT '总时长(分钟)',
  `course_list_img` varchar(255) DEFAULT NULL COMMENT '课程列表展示图片',
  `status` int(2) DEFAULT '0' COMMENT '课程状态，0-草稿，1-上架',
  `sort_num` int(11) DEFAULT NULL COMMENT '课程排序，用于后台保存草稿时用到',
  `preview_first_field` varchar(255) DEFAULT NULL COMMENT '课程预览第一个字段',
  `preview_second_field` varchar(255) DEFAULT NULL COMMENT '课程预览第二个字段',
  `sales` int(11) DEFAULT '0' COMMENT '销量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of course
-- ----------------------------
BEGIN;
INSERT INTO `course` VALUES (18, '前端架构设计', 'Vue', 600.00, '', 600.00, '前端', '<p>非常漂亮</p>\n', NULL, 'http://localhost:8080/upload/1652532515886.jpeg', NULL, NULL, NULL, NULL, '2022-05-14 20:49:20', '2022-05-22 14:30:09', 0, NULL, '', 0, 4, 'Vue 这个前端框架的使用', '十几个章节', 4);
INSERT INTO `course` VALUES (19, 'Web开发技术', 'Java企业级', 600.00, '', 600.00, '123', '<p>阿斯达万达掌心脆</p>\n', NULL, '', NULL, NULL, NULL, NULL, '2022-05-16 00:08:54', '2022-05-22 14:29:59', 0, NULL, '', 0, 4, '20', '阿达瓦', 7);
INSERT INTO `course` VALUES (20, '高等数学', '大学第一数学', 800.00, '', 800.00, '数学', '<p>大学入门课程</p>\n', NULL, 'http://localhost:8080/upload/1653190256713.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:32:35', '2022-05-22 11:42:44', 0, NULL, '', 1, 1, '每个学分200元', '优秀的老师', 0);
INSERT INTO `course` VALUES (21, '大学英语1', '大学英语', 600.00, '', 1200.00, '英语', '<p>这是一门大学入门英语</p>\n', NULL, 'http://localhost:8080/upload/1653190654252.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:38:02', '2022-05-22 11:42:43', 0, NULL, '', 1, 1, '每学分200元 ', '我挂了 多加600', 0);
INSERT INTO `course` VALUES (22, '程序设计基础', 'c语言', 800.00, '', 800.00, '编程语言', '<p>大学入门的编程语言</p>\n', NULL, 'http://localhost:8080/upload/1653190800283.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:40:48', '2022-05-22 11:42:42', 0, NULL, '', 1, 1, '每个学分200', '', 0);
INSERT INTO `course` VALUES (23, '大学计算机基础', '计算机入门课', 400.00, '', 400.00, '基础课', '<p>基础课程</p>\n', NULL, 'http://localhost:8080/upload/1653190922191.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:42:34', '2022-05-22 11:42:41', 0, NULL, '', 1, 1, '每个学分200', '', 0);
INSERT INTO `course` VALUES (24, '计算机组装与维护', '计算机硬件课程', 400.00, '', 400.00, '硬件', '<p>计算机硬件基础课程</p>\n', NULL, 'http://localhost:8080/upload/1653191087295.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:45:33', '2022-05-22 14:35:30', 0, NULL, '', 1, 1, '每个学分200', '', 0);
INSERT INTO `course` VALUES (25, '面向对象程序设计', 'Java语言', 800.00, '', 800.00, '', '', NULL, 'http://localhost:8080/upload/1653191180594.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:46:52', '2022-05-22 14:35:31', 0, NULL, '', 1, 2, '每个学分200', '', 0);
INSERT INTO `course` VALUES (26, '前端设计技术', 'HTML、CSS、JavaScript', 600.00, '', 600.00, '', '', NULL, 'http://localhost:8080/upload/1653191288841.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:48:19', '2022-05-22 14:35:34', 0, NULL, '', 1, 2, '每个学分200', '', 0);
INSERT INTO `course` VALUES (27, '高等数学A（Ⅱ）', '高数2', 800.00, '', 800.00, '', '', NULL, 'http://localhost:8080/upload/1653191369339.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:49:45', '2022-05-22 14:35:35', 0, NULL, '', 1, 2, '每个学分200', '', 0);
INSERT INTO `course` VALUES (28, '线性代数', '数学3', 400.00, '', 400.00, '', '', NULL, 'http://localhost:8080/upload/1653191465693.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:51:21', '2022-05-22 14:35:36', 0, NULL, '', 1, 3, '每个学分200', '', 0);
INSERT INTO `course` VALUES (29, '数据库原理及应用', '数据库课程', 600.00, '', 600.00, '', '', NULL, 'http://localhost:8080/upload/1653191532551.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 11:52:23', '2022-05-22 14:35:38', 0, NULL, '', 1, 3, '每个学分200', '', 0);
INSERT INTO `course` VALUES (30, '操作系统', '软件底层知识', 800.00, '', 800.00, '', '', NULL, 'http://localhost:8080/upload/1653200297438.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 14:18:29', '2022-05-22 14:35:39', 0, NULL, '', 1, 3, '每个学分200', '', 0);
INSERT INTO `course` VALUES (31, '计算机网络', '计算机四大基础课程之一', 600.00, '', 600.00, '', '', NULL, 'http://localhost:8080/upload/1653200372219.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 14:19:52', '2022-05-22 14:35:40', 0, NULL, '', 1, 3, '每个学分200', '', 0);
INSERT INTO `course` VALUES (32, '大学英语3', '欧美文学', 400.00, '', 400.00, '', '', NULL, 'http://localhost:8080/upload/1653200486598.png', NULL, NULL, NULL, NULL, '2022-05-22 14:21:34', '2022-05-22 14:35:41', 0, NULL, '', 1, 3, '每个学分200', '', 0);
INSERT INTO `course` VALUES (33, 'Python语言基础', 'Python语言', 600.00, '', 600.00, '', '', NULL, 'http://localhost:8080/upload/1653200542631.jpeg', NULL, NULL, NULL, NULL, '2022-05-22 14:22:53', '2022-05-22 14:35:43', 0, NULL, '', 1, 3, '每个学分200', '', 0);
INSERT INTO `course` VALUES (34, '大学英语2', '大学英语', 600.00, '', 600.00, '', '', NULL, 'http://localhost:8080/upload/1653200829394.png', NULL, NULL, NULL, NULL, '2022-05-22 14:27:22', '2022-05-22 14:35:44', 0, NULL, '', 1, 2, '每个学分200', '', 0);
INSERT INTO `course` VALUES (35, '数据分析', '胡安明', 600.00, '', 600.00, '', '', NULL, '', NULL, NULL, NULL, NULL, '2022-05-22 14:30:52', '2022-05-22 14:30:52', 0, NULL, '', 0, 4, '每个学分200', '', 0);
INSERT INTO `course` VALUES (36, 'Linux操作系统应用', 'Linux操作系统应用', 600.00, '', 600.00, '', '', NULL, '', NULL, NULL, NULL, NULL, '2022-05-22 14:31:55', '2022-05-22 14:31:55', 0, NULL, '', 0, 4, '每个学分200', '', 0);
INSERT INTO `course` VALUES (37, '概率论与数理统计', '好难的', 600.00, '', 600.00, '', '', NULL, '', NULL, NULL, NULL, NULL, '2022-05-22 14:35:23', '2022-05-22 14:35:23', 0, NULL, '', 0, 4, '每个学分200', '', 0);
INSERT INTO `course` VALUES (38, '大学英语4', '中国文学概述', 400.00, '', 400.00, '', '', NULL, '', NULL, NULL, NULL, NULL, '2022-05-22 14:37:03', '2022-05-22 14:37:03', 0, NULL, '', 0, 4, '每个学分200', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for course_lesson
-- ----------------------------
DROP TABLE IF EXISTS `course_lesson`;
CREATE TABLE `course_lesson` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `course_id` int(11) NOT NULL COMMENT '课程id',
  `section_id` int(11) NOT NULL DEFAULT '0' COMMENT '章节id',
  `theme` varchar(255) NOT NULL COMMENT '课时主题',
  `duration` int(11) NOT NULL DEFAULT '0' COMMENT '课时时长(分钟)',
  `is_free` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否免费',
  `create_time` datetime NOT NULL COMMENT '记录创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `order_num` int(11) DEFAULT NULL COMMENT '排序字段',
  `status` int(2) DEFAULT '0' COMMENT '课时状态,0-隐藏，1-未发布，2-已发布',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `course_id_index` (`course_id`,`section_id`) USING BTREE,
  KEY `idx_sectionId_orderNum` (`section_id`,`order_num`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='课程节内容';

-- ----------------------------
-- Records of course_lesson
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for course_media
-- ----------------------------
DROP TABLE IF EXISTS `course_media`;
CREATE TABLE `course_media` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程媒体主键ID',
  `course_id` int(11) DEFAULT NULL COMMENT '课程Id',
  `section_id` int(11) DEFAULT NULL COMMENT '章ID',
  `lesson_id` int(11) DEFAULT NULL COMMENT '课时ID',
  `cover_image_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面图URL',
  `duration` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '时长（06:02）',
  `file_edk` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '媒体资源文件对应的EDK',
  `file_size` double(10,2) DEFAULT NULL COMMENT '文件大小MB',
  `file_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称',
  `file_dk` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '媒体资源文件对应的DK',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '是否删除，0未删除，1删除',
  `duration_num` int(11) DEFAULT NULL COMMENT '时长，秒数（主要用于音频在H5控件中使用）',
  `file_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '媒体资源文件ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq_lessonid_channel_mediatype_idx` (`lesson_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of course_media
-- ----------------------------
BEGIN;
INSERT INTO `course_media` VALUES (5, 7, 7, 8, 'http://outin-61fd129aa62411eaa4ef00163e1c94a4.oss-cn-shanghai.aliyuncs.com/image/cover/7FDABE200A424897A7ED5CE05764BB4C-6-2.png?Expires=1594363749&OSSAccessKeyId=LTAIVVfYx6D0HeL2&Signature=dqBQJCvfJY1wDCBgCGnI5cPInww%3D', '00:11', 'YTU5ZGFkM2ItOGI0Mi00NWFmLWJiMGItMTI4YWRjNjQzOWFlRjdaVUlmYTUwYWkwR3pwK1YzZENnUjExMnI1VkxiVFhBQUFBQUFBQUFBQ3FJN3pnZnFQUndad24rT2djTmM4MkxXb3ZXcDNNNkk0RENXeW9NRDVrZFNucHFiaUxRNm4r', 1.90, '屏幕录制2020-07-10 13.48.08.mov', 'JPagaxcX6Ihpn5nu+dLi0Q==', '2020-07-10 11:14:51', '2020-07-10 13:49:14', 0, 11, '4f0dfb878a4d4d4881428b950396228a');
INSERT INTO `course_media` VALUES (6, 7, 8, 10, 'http://outin-61fd129aa62411eaa4ef00163e1c94a4.oss-cn-shanghai.aliyuncs.com/image/cover/DBA8C56E2EA44F6382DCF5B7AD5763E6-6-2.png?Expires=1594356125&OSSAccessKeyId=LTAIVVfYx6D0HeL2&Signature=s5jKXcyQzw%2BjJKah75oBobYEy3g%3D', '00:08', 'YTU5ZGFkM2ItOGI0Mi00NWFmLWJiMGItMTI4YWRjNjQzOWFlNDlJL3pGM0dvS1IzSFhxMkFzNnYwcnhBelB6bUU3NENBQUFBQUFBQUFBQkxYTzQ4Q2JyK05XTHRoKzZiWmpoZG55azJ5NFVYUWtIRUhWb1BuQ3FZd2FPTVhPM2d6UDJ4', 0.64, '测试视频课程.mp4', 'T3q/VVunsKwx7aNeRtaLGg==', '2020-07-10 11:17:38', '2020-07-10 11:42:10', 0, 8, '8dbf98ac948a4b389f99f17034c998cd');
INSERT INTO `course_media` VALUES (7, 8, 9, 12, 'http://outin-61fd129aa62411eaa4ef00163e1c94a4.oss-cn-shanghai.aliyuncs.com/image/cover/07ED3325C001418AA46A95F88B1DA6C8-6-2.png?Expires=1594969610&OSSAccessKeyId=LTAIVVfYx6D0HeL2&Signature=biyZXbn1V2gY4GxmPiXKBME3E7I%3D', '00:05', 'YTU5ZGFkM2ItOGI0Mi00NWFmLWJiMGItMTI4YWRjNjQzOWFlaWxjVHdDaW5NSDJGTWdqZnYxWFg1YWZ6OUJXc0cvS3FBQUFBQUFBQUFBQzVwV2NTQUh4NjhiaU1YZ1drYlFZQnlVKyt0YkdTRzdlVXJmRFVOZHRESWM3T3ZSdEwwM1hN', 11.37, 'test.mov', 'BRRHQV/DivcEwf0Zosn9dA==', '2020-07-10 11:40:29', '2020-07-17 14:06:55', 0, 5, 'a029c496959a457e92eb9e4f480e0018');
INSERT INTO `course_media` VALUES (8, 7, 8, 11, 'http://outin-61fd129aa62411eaa4ef00163e1c94a4.oss-cn-shanghai.aliyuncs.com/image/cover/8D2E8BB920F94ECAB32CCAA73222DF32-6-2.png?Expires=1594625842&OSSAccessKeyId=LTAIVVfYx6D0HeL2&Signature=H2rqXRF0a%2FjY1dnrVtACXinwBRI%3D', '00:08', 'YTU5ZGFkM2ItOGI0Mi00NWFmLWJiMGItMTI4YWRjNjQzOWFlQnBqQnBlU042WEd4UWx2eVEwV1hZS2JQdE5PS1dBYVpBQUFBQUFBQUFBQ0ViRHkrd0U1WWVLRGhObFJGOFE5OGJMYlppRzNwdnVWc2xuUnpINnVhN3dkay9QMDlucXhR', 0.64, '测试视频课程.mp4', 'MWGs74Qco6LYjlCXc7ymEg==', '2020-07-10 11:43:10', '2020-07-13 14:37:27', 0, 8, 'bb7d23a9334c4b07abb1187a2c61ce1f');
INSERT INTO `course_media` VALUES (9, 8, 9, 13, 'http://outin-61fd129aa62411eaa4ef00163e1c94a4.oss-cn-shanghai.aliyuncs.com/image/cover/1B8791F4BC4B48B08A37C2B7B669FE52-6-2.png?Expires=1594356307&OSSAccessKeyId=LTAIVVfYx6D0HeL2&Signature=QISH8TpvWX%2F0G%2B%2F1rA0OJqTug3g%3D', '00:08', 'YTU5ZGFkM2ItOGI0Mi00NWFmLWJiMGItMTI4YWRjNjQzOWFlSHk2RWhDUURHejlyYzN1cnNNaE9ubG9jVUZlb2NTbFFBQUFBQUFBQUFBQjRRV0lGOHRvUGxIcCtINGhTdWxBR3JWV1ZmR3ZDT3R2YnVJcDlkS0NjSWxoL1EwMmpHcVdK', 0.64, '测试视频课程.mp4', 'B0CqECTjmT1JeCVndYvXtg==', '2020-07-10 11:45:13', '2020-07-10 11:45:13', 0, 8, '717bc01edbb24283937d7fa903f06d60');
INSERT INTO `course_media` VALUES (10, 9, 10, 14, 'http://outin-61fd129aa62411eaa4ef00163e1c94a4.oss-cn-shanghai.aliyuncs.com/image/cover/EEB28294E90F4D85A2609A2A978A9264-6-2.png?Expires=1594356669&OSSAccessKeyId=LTAIVVfYx6D0HeL2&Signature=wR9JpRJp6UMBs%2B55QSWSFYBM%2FCs%3D', '00:08', 'YTU5ZGFkM2ItOGI0Mi00NWFmLWJiMGItMTI4YWRjNjQzOWFlajlJcXU0RGYyc0V2blZ5c0pXMGVDaUdNT0ZVZlNYODVBQUFBQUFBQUFBQjFKWCtoZGU4WDZPTXM3RnZmanFXTWxzVVh0Uy80OEt6U2ttY1h1TDJURlJ6dlJ3V2ZpcjFT', 0.64, '测试视频课程.mp4', '6I5a1R2dG/WrUCQotk6Uxw==', '2020-07-10 11:51:14', '2020-07-10 11:51:14', 0, 8, '451d48ec785646b8ab1aa97ae3741100');
COMMIT;

-- ----------------------------
-- Table structure for course_section
-- ----------------------------
DROP TABLE IF EXISTS `course_section`;
CREATE TABLE `course_section` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `course_id` int(11) DEFAULT NULL COMMENT '课程id',
  `section_name` varchar(255) NOT NULL DEFAULT '' COMMENT '章节名',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '章节描述',
  `create_time` datetime NOT NULL COMMENT '记录创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `order_num` int(11) DEFAULT NULL COMMENT '排序字段',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '状态，0:隐藏；1：待更新；2：已发布',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `course_id_index` (`course_id`) USING BTREE,
  KEY `idx_course_id` (`course_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of course_section
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `parent_id` int(11) NOT NULL COMMENT '父菜单id',
  `href` varchar(200) DEFAULT NULL COMMENT '菜单路径',
  `icon` varchar(200) DEFAULT NULL COMMENT '菜单图标',
  `name` varchar(200) DEFAULT NULL COMMENT '菜单名称',
  `description` varchar(500) DEFAULT NULL COMMENT '描述',
  `order_num` int(11) DEFAULT NULL COMMENT '排序号',
  `shown` tinyint(2) DEFAULT '1' COMMENT '是否展示',
  `level` int(11) NOT NULL COMMENT '菜单层级，从0开始',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COMMENT='菜单表';

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (1, -1, '', 'lock', '权限管理', '管理系统角色、菜单、资源', 1, 1, 0, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (2, 1, 'Role', 'lock', '角色列表', '管理系统角色', 1, 1, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (3, 1, 'Menu', 'lock', '菜单列表', '管理系统菜单', 2, 1, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (4, 1, 'Resource', 'lock', '资源列表', '管理系统资源', 3, 1, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (5, -1, 'Courses', 'film', '课程管理', '课程的新增、修改、查看、发布、上下架', 2, 1, 0, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (6, -1, 'Users', 'user', '用户管理', '用户的查询、禁用、启用', 3, 1, 0, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (7, -1, '', 'setting', '广告管理', '广告、广告位管理', 4, 1, 0, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (8, 7, 'Advertise', 'setting', '广告列表', '广告管理', 1, 1, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (9, 7, 'AdvertiseSpace', 'setting', '广告位列表', '广告位管理', 2, 1, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (10, 1, 'AllocMenu', 'setting', '给角色分配菜单页面', '给角色分配菜单页面路由', 4, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (11, 1, 'AllocResource', 'setting', '给角色分配资源页面', '给角色分配资源页面路由', 5, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (12, 1, 'AddMenu', 'setting', '添加菜单页面', '添加菜单页路由', 6, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (13, 1, 'UpdateMenu', 'setting', '更新菜单页面', '更新菜单页路由', 7, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (14, 1, 'ResourceCategory', 'setting', '资源分类列表页面', '资源分类列表页面路由', 8, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (15, 7, 'AddAdvertise', 'setting', '添加广告页面', '添加广告页面路由', 3, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (16, 7, 'UpdateAdvertise', 'setting', '编辑广告页面', '编辑广告页面路由', 4, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (17, 7, 'AddAdvertiseSpace', 'setting', '添加广告位页面', '添加广告位页面路由', 5, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (18, 7, 'UpdateAdvertiseSpace', 'setting', '更新广告位页面', '更新广告位页面路由', 6, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (19, 5, 'CourseItem', 'setting', '课程详情页面', '课程详情页面路由', 1, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (20, 5, 'CourseSections', 'setting', '课时信息页面', '课时信息页面路由', 2, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (21, 5, 'VideoOptions', 'setting', '课时上传视频', '课时上传视频页面路由', 3, 0, 1, '2020-07-20 15:41:38', '2020-07-20 15:41:38', 'system', 'system');
INSERT INTO `menu` VALUES (22, 5, 'updateStatus', 'lock', '课程管理状态', '设置课程状态', 3, 0, 0, '2020-08-11 04:32:41', '2020-08-11 04:32:41', 'system', 'system');
INSERT INTO `menu` VALUES (27, 5, 'updateStatus', 'lock', '课程管理状态', '设置课程状态', 3, 0, 0, '2020-08-11 04:32:41', '2020-08-11 04:32:41', 'system', 'system');
INSERT INTO `menu` VALUES (28, 5, 'updateStatus', 'lock', '课程管理状态', 'updateStatus', 2, 0, 0, '2022-05-17 00:35:17', '2022-05-17 00:36:03', 'system', 'song');
COMMIT;

-- ----------------------------
-- Table structure for promotion_ad
-- ----------------------------
DROP TABLE IF EXISTS `promotion_ad`;
CREATE TABLE `promotion_ad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '广告名',
  `spaceId` int(11) DEFAULT NULL COMMENT '广告位id',
  `keyword` varchar(255) DEFAULT NULL COMMENT '精确搜索关键词',
  `htmlContent` text COMMENT '静态广告的内容',
  `text` varchar(255) DEFAULT NULL COMMENT '文字一',
  `link` varchar(255) DEFAULT NULL COMMENT '链接一',
  `startTime` datetime DEFAULT NULL COMMENT '开始时间',
  `endTime` datetime DEFAULT NULL COMMENT '结束时间',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `status` int(2) NOT NULL DEFAULT '0',
  `priority` int(4) DEFAULT '0' COMMENT '优先级',
  `img` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `promotion_ad_SEG` (`spaceId`,`startTime`,`endTime`,`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1095 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of promotion_ad
-- ----------------------------
BEGIN;
INSERT INTO `promotion_ad` VALUES (1074, 'SpringBoot', 3, NULL, NULL, 'sdfsadf', 'www.song.com', '2020-06-23 17:03:27', '2020-07-29 17:03:45', '2020-07-14 14:28:34', '2022-05-22 14:44:13', 1, 0, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1075, '精选课程', 2, NULL, NULL, '阿斯达', 'http://www.song.com/#/content?courseId=1', '2020-06-29 17:03:25', '2020-07-29 17:03:45', '2020-07-14 14:28:34', '2022-05-16 00:20:23', 1, 0, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1076, 'Java', 3, NULL, NULL, NULL, 'www.song.com', '2020-06-29 17:03:25', '2020-07-29 17:03:45', '2020-07-14 14:28:34', '2022-05-22 14:43:55', 1, 0, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1077, '轮播广告2', 3, NULL, NULL, NULL, 'www.song.com', '2020-06-29 17:03:25', '2020-07-29 17:03:45', '2020-07-14 14:28:34', '2022-05-06 15:16:22', 1, 0, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1078, 'songsong', 162, NULL, NULL, '这是文本内容', 'www.song.com', '2022-01-03 00:00:00', '2022-05-17 15:54:06', '2020-07-14 14:28:34', '2022-05-17 15:54:26', 1, 2, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1079, '广告', 162, NULL, NULL, '这是文本内容111', 'www.song.com', '2020-07-01 00:00:00', '2020-08-01 00:00:00', '2020-07-14 14:30:48', '2022-05-22 14:45:23', 1, 2, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1080, '广告名称', 169, NULL, NULL, 'text', 'link1', '2030-01-10 01:01:01', '2030-01-02 12:12:12', '2020-07-14 16:38:03', '2022-05-22 14:45:28', 1, 0, 'http://localhost:8080/upload/1652776483767.jpeg');
INSERT INTO `promotion_ad` VALUES (1094, 'Python', 1, NULL, NULL, '大家一起学Python', 'www.song.com', '2021-08-03 06:12:08', '2022-05-17 16:34:53', '2022-05-17 15:26:54', '2022-05-22 14:44:25', 1, 0, 'http://localhost:8080/upload/1652776483767.jpeg');
COMMIT;

-- ----------------------------
-- Table structure for promotion_space
-- ----------------------------
DROP TABLE IF EXISTS `promotion_space`;
CREATE TABLE `promotion_space` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `spaceKey` varchar(255) DEFAULT NULL COMMENT '广告位key',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `isDel` int(2) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `promotion_space_key_isDel` (`spaceKey`,`isDel`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of promotion_space
-- ----------------------------
BEGIN;
INSERT INTO `promotion_space` VALUES (1, '页面头部广告位', '666', '2020-07-14 13:03:31', '2022-05-05 19:31:50', 0);
INSERT INTO `promotion_space` VALUES (2, '首页侧边广告位', '888', '2020-07-14 13:03:31', '2020-07-17 11:53:02', 0);
INSERT INTO `promotion_space` VALUES (3, '首页顶部轮播', '999', '2020-07-14 13:03:31', '2020-07-17 13:13:03', 0);
INSERT INTO `promotion_space` VALUES (162, '广告名称', '789', '2020-07-14 13:03:31', '2020-07-14 13:03:11', 0);
INSERT INTO `promotion_space` VALUES (163, '广告名称', '78911111', '2020-07-14 13:03:31', '2020-07-14 13:03:11', 0);
INSERT INTO `promotion_space` VALUES (164, '广告名称', '78911111', '2020-07-14 13:03:31', '2020-07-14 13:03:11', 0);
INSERT INTO `promotion_space` VALUES (165, '广告名称', '78911111', '2020-07-14 13:03:31', '2020-07-14 13:03:11', 0);
INSERT INTO `promotion_space` VALUES (166, '广告名称', '78911111', '2020-07-14 13:03:31', '2020-07-14 13:03:11', 0);
INSERT INTO `promotion_space` VALUES (167, '广告名称', '78911111', '2020-07-14 13:03:31', '2020-07-14 13:03:11', 0);
INSERT INTO `promotion_space` VALUES (168, '广告名称111', '33333', '2020-07-14 13:03:31', '2020-07-14 13:03:49', 0);
INSERT INTO `promotion_space` VALUES (169, '页面头部广告位', 'abcd', '2020-07-14 16:30:38', '2022-05-05 19:32:34', 0);
INSERT INTO `promotion_space` VALUES (172, '页面头部广告位', 'bcbadfa3-e6d1-4df5-9ab0-c6749a5a3c73', '2022-05-05 19:31:14', '2022-05-05 19:31:14', 0);
INSERT INTO `promotion_space` VALUES (173, '页面头部', 'eec0189c-75df-4f0d-b262-1c88598ac87a', '2022-05-05 19:34:27', '2022-05-17 14:33:13', 0);
COMMIT;

-- ----------------------------
-- Table structure for resource
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源id',
  `name` varchar(200) NOT NULL COMMENT '资源名称',
  `url` varchar(200) NOT NULL COMMENT '资源url',
  `category_id` int(11) DEFAULT NULL COMMENT '分类id',
  `description` varchar(500) DEFAULT NULL COMMENT '简介',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`),
  KEY `idx_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COMMENT='资源表';

-- ----------------------------
-- Records of resource
-- ----------------------------
BEGIN;
INSERT INTO `resource` VALUES (1, '获取所有角色', '/boss/role/all', 1, '获取所有角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (2, '给用户分配角色', '/boss/role/allocateUserRoles', 1, '给用户分配角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (3, '按条件查询角色', '/boss/role/getRolePages', 1, '按条件查询角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (4, '列出所有角色并标记用户是否拥有', '/boss/role/getRolesWithUserPermission', 1, '列出所有角色并标记用户是否拥有', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (5, '保存或者更新角色', '/boss/role/saveOrUpdate', 1, '保存或者更新角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (6, '查询用户角色', '/boss/role/user/{userId}', 1, '查询用户角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (7, '获取角色', '/boss/role/{id}', 1, '获取角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (8, '删除角色', '/boss/role/{id}', 1, '删除角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (9, '给角色分配菜单', '/boss/menu/allocateRoleMenus', 2, '给角色分配菜单', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (10, '获取所有菜单', '/boss/menu/getAll', 2, '获取所有菜单', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (11, '获取编辑菜单页面信息', '/boss/menu/getEditMenuInfo', 2, '获取编辑菜单页面信息', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (12, '获取所有菜单并按层级展示', '/boss/menu/getMenuNodeList', 2, '获取所有菜单并按层级展示', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (13, '按条件分页查询菜单', '/boss/menu/getMenuPages', 2, '按条件分页查询菜单', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (14, '获取角色拥有的菜单列表', '/boss/menu/getRoleMenus', 2, '获取角色拥有的菜单列表', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (15, '保存或新增菜单', '/boss/menu/saveOrUpdate', 2, '保存或新增菜单', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (16, '是否显示开关', '/boss/menu/switchShown', 2, '是否显示开关', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (17, '根据ID查询菜单', '/boss/menu/{id}', 2, '根据ID查询菜单', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (18, '删除菜单', '/boss/menu/{id}', 2, '删除菜单', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (19, '给角色分配资源', '/boss/resource/allocateRoleResources', 3, '给角色分配资源', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (20, '查询资源分类列表', '/boss/resource/category/getAll', 3, '查询资源分类列表', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (21, '保存或更新资源分类', '/boss/resource/category/saveOrderUpdate', 3, '保存或更新资源分类', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (22, '删除资源分类', '/boss/resource/category/{id}', 3, '删除资源分类', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (23, '获取所有资源', '/boss/resource/getAll', 3, '获取所有资源', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (24, '按条件分页查询资源', '/boss/resource/getResourcePages', 3, '按条件分页查询资源', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (25, '获取角色拥有的资源列表', '/boss/resource/getRoleResources', 3, '获取角色拥有的资源列表', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (26, '保存或者更新资源', '/boss/resource/saveOrUpdate', 3, '保存或者更新资源', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (27, '获取资源', '/boss/resource/{id}', 3, '获取资源', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (28, '删除资源', '/boss/resource/{id}', 3, '删除资源', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (29, '封禁用户', '/boss/user/forbidUser', 5, '封禁用户', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (30, '分页查询用户信息', '/boss/user/getUserPages', 5, '分页查询用户信息', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (31, '获取用户菜单和资源权限列表', '/boss/permission/getUserPermissions', 5, '获取用户菜单和资源权限列表', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (32, '查询用户角色', '/boss/role/user/{userId}', 1, '查询用户角色', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (33, '课程上下架', '/boss/course/changeState', 4, '课程上下架', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (34, '新建课程页面路由', '/boss/courses/new', 4, '新建课程页面路由', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (35, '通过课程Id获取课程信息', '/boss/course/getCourseById', 4, '通过课程Id获取课程信息', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (36, '分页查询课程信息', '/boss/course/getQueryCourses', 4, '分页查询课程信息', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (37, '保存或者更新课程信息', '/boss/course/saveOrUpdateCourse', 4, '保存或者更新课程信息', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (38, '上传图片', '/boss/course/upload', 4, '上传图片', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (39, '保存活动商品', '/boss/activityCourse/save', 4, '保存活动商品', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (40, '更新活动商品状态', '/boss/activityCourse/updateStatus', 4, '更新活动商品状态', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (41, '获取章节', '/boss/course/section/getBySectionId', 4, '获取章节', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (42, '获取章节和课时', '/boss/course/section/getSectionAndLesson', 4, '获取章节和课时', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (43, '保存或更新章节', '/boss/course/section/saveOrUpdateSection', 4, '保存或更新章节', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (44, '获取课时内容', '/boss/course/lesson/getById', 4, '获取课时内容', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (45, '保存或更新课时', '/boss/course/lesson/saveOrUpdate', 4, '保存或更新课时', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (46, '获取阿里云图片上传凭证', '/boss/course/upload/aliyunImagUploadAddressAdnAuth.json', 6, '获取阿里云图片上传凭证', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (47, '阿里云转码请求', '/boss/course/upload/aliyunTransCode.json', 6, '阿里云转码请求', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (48, '阿里云转码进度', '/boss/course/upload/aliyunTransCodePercent.json', 6, '阿里云转码进度', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (49, '获取阿里云视频上传凭证', '/boss/course/upload/aliyunVideoUploadAddressAdnAuth.json', 6, '获取阿里云视频上传凭证', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (50, '获取媒体信息', '/boss/course/upload/getMediaByLessonId.json', 6, '获取媒体信息', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (51, '刷新阿里云视频上传凭证', '/boss/course/upload/refreshAliyunVideoUploadAddressAdnAuth.json', 6, '刷新阿里云视频上传凭证', '2020-07-20 15:41:57', '2020-07-20 15:41:57', 'system', 'system');
INSERT INTO `resource` VALUES (53, '湿哒哒大多', '阿魏酸所', 6, '最真啊', '2022-05-16 00:12:17', '2022-05-16 00:12:41', 'system', 'system1');
COMMIT;

-- ----------------------------
-- Table structure for resource_category
-- ----------------------------
DROP TABLE IF EXISTS `resource_category`;
CREATE TABLE `resource_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL COMMENT '分类名称',
  `sort` int(4) DEFAULT NULL COMMENT '排序',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='资源分类表';

-- ----------------------------
-- Records of resource_category
-- ----------------------------
BEGIN;
INSERT INTO `resource_category` VALUES (1, '角色管理', 1, '2020-07-20 15:41:46', '2020-07-20 15:41:46', 'system', 'system');
INSERT INTO `resource_category` VALUES (2, '菜单管理', 2, '2020-07-20 15:41:46', '2020-07-20 15:41:46', 'system', 'system');
INSERT INTO `resource_category` VALUES (3, '资源管理', 3, '2020-07-20 15:41:46', '2020-07-20 15:41:46', 'system', 'system');
INSERT INTO `resource_category` VALUES (4, '课程管理', 4, '2020-07-20 15:41:46', '2020-07-20 15:41:46', 'system', 'system');
INSERT INTO `resource_category` VALUES (5, '用户管理', 5, '2020-07-20 15:41:46', '2020-07-20 15:41:46', 'system', 'system');
INSERT INTO `resource_category` VALUES (6, '阿里上传', 6, '2020-07-20 15:41:46', '2020-07-20 15:41:46', 'system', 'system');
INSERT INTO `resource_category` VALUES (7, '广告管理', 0, '2020-07-20 07:57:10', '2020-07-20 07:57:10', '15510792994', '15510792994');
COMMIT;

-- ----------------------------
-- Table structure for role_menu_relation
-- ----------------------------
DROP TABLE IF EXISTS `role_menu_relation`;
CREATE TABLE `role_menu_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `menu_id` int(11) NOT NULL COMMENT '菜单id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关系表';

-- ----------------------------
-- Records of role_menu_relation
-- ----------------------------
BEGIN;
INSERT INTO `role_menu_relation` VALUES (54, 7, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (55, 8, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (56, 9, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (57, 15, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (58, 16, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (59, 17, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (60, 18, 4, '2022-05-21 18:04:23', '2022-05-21 18:04:23', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (61, 5, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (62, 19, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (63, 20, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (64, 21, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (65, 22, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (66, 27, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (67, 28, 3, '2022-05-21 18:04:30', '2022-05-21 18:04:30', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (68, 1, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (69, 2, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (70, 3, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (71, 4, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (72, 10, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (73, 11, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (74, 12, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (75, 13, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (76, 14, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (77, 6, 2, '2022-05-21 18:04:40', '2022-05-21 18:04:40', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (78, 1, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (79, 2, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (80, 3, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (81, 4, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (82, 10, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (83, 11, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (84, 12, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (85, 13, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (86, 14, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (87, 5, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (88, 19, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (89, 20, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (90, 21, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (91, 22, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (92, 27, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (93, 28, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (94, 6, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (95, 7, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (96, 8, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (97, 9, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (98, 15, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (99, 16, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (100, 17, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
INSERT INTO `role_menu_relation` VALUES (101, 18, 1, '2022-05-21 18:04:48', '2022-05-21 18:04:48', 'system', 'system');
COMMIT;

-- ----------------------------
-- Table structure for role_resource_relation
-- ----------------------------
DROP TABLE IF EXISTS `role_resource_relation`;
CREATE TABLE `role_resource_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关系id',
  `resource_id` int(11) NOT NULL COMMENT '资源id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COMMENT='角色和资源关系表';

-- ----------------------------
-- Records of role_resource_relation
-- ----------------------------
BEGIN;
INSERT INTO `role_resource_relation` VALUES (7, 7, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (8, 8, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (9, 9, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (10, 10, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (11, 11, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (12, 12, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (13, 13, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (14, 14, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (15, 15, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (16, 16, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (17, 17, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (18, 18, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (19, 19, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (20, 20, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (21, 21, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (22, 22, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (23, 23, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (24, 24, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (25, 25, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (26, 26, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (27, 27, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (28, 28, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (29, 29, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (30, 30, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (31, 31, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (32, 32, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (33, 33, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (34, 34, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (35, 35, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (36, 36, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (37, 37, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (38, 38, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (39, 39, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (40, 40, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (41, 41, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (42, 42, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (43, 43, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (44, 44, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (45, 45, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (46, 46, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (47, 47, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (48, 48, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (49, 49, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (50, 50, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (51, 51, 1, '2020-07-20 15:42:11', '2020-07-20 15:42:11', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (58, 7, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (59, 8, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (60, 9, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (61, 10, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (62, 11, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (63, 12, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (64, 13, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (65, 14, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (66, 15, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (67, 16, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (68, 17, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (69, 18, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (70, 19, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (71, 20, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (72, 21, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (73, 22, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (74, 23, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (75, 24, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (76, 25, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (77, 26, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (78, 27, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (79, 28, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (80, 29, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (81, 30, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (82, 31, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (83, 32, 2, '2020-07-20 07:50:39', '2020-07-20 07:50:39', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (84, 33, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (85, 34, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (86, 35, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (87, 36, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (88, 37, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (89, 38, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (90, 39, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (91, 40, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (92, 41, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (93, 42, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (94, 43, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (95, 44, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (96, 45, 3, '2020-07-20 07:55:32', '2020-07-20 07:55:32', '15510792994', '15510792994');
INSERT INTO `role_resource_relation` VALUES (97, 32, 4, '2020-07-22 04:23:25', '2020-07-22 04:23:25', '15321919577', '15321919577');
INSERT INTO `role_resource_relation` VALUES (104, 7, 4, '2020-07-22 04:23:25', '2020-07-22 04:23:25', '15321919577', '15321919577');
INSERT INTO `role_resource_relation` VALUES (108, 9, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (109, 10, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (110, 11, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (111, 12, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (112, 13, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (113, 14, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (114, 15, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (115, 16, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (116, 17, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (117, 18, 5, '2022-05-12 12:17:38', '2022-05-12 12:17:38', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (120, 7, 6, '2022-05-16 00:14:16', '2022-05-16 00:14:16', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (121, 22, 6, '2022-05-16 00:14:16', '2022-05-16 00:14:16', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (122, 25, 6, '2022-05-16 00:14:16', '2022-05-16 00:14:16', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (123, 28, 6, '2022-05-16 00:14:16', '2022-05-16 00:14:16', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (124, 1, 1, '2022-05-21 18:02:51', '2022-05-21 18:02:51', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (128, 7, 1, '2022-05-21 18:02:51', '2022-05-21 18:02:51', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (129, 8, 1, '2022-05-21 18:02:51', '2022-05-21 18:02:51', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (130, 9, 1, '2022-05-21 18:02:51', '2022-05-21 18:02:51', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (131, 10, 1, '2022-05-21 18:02:51', '2022-05-21 18:02:51', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (132, 1, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (133, 2, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (136, 5, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (137, 6, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (138, 7, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (139, 8, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (140, 9, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
INSERT INTO `role_resource_relation` VALUES (141, 10, 2, '2022-05-21 18:03:41', '2022-05-21 18:03:41', 'system', 'system');
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `code` varchar(100) NOT NULL COMMENT '角色code',
  `name` varchar(200) DEFAULT NULL COMMENT '角色名称',
  `description` varchar(500) DEFAULT NULL COMMENT '简介',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES (1, 'ADMIN', '超级管理员', '后台管理员，初始拥有权限管理功能', '2020-07-20 15:41:29', '2020-07-20 15:41:29', 'system', 'system');
INSERT INTO `roles` VALUES (2, 'AUTHORITY_MANAGER', '权限管理员', '管理权限相关数据，如角色、菜单、资源。可以给用户分配角色。', '2020-07-20 07:47:55', '2020-07-20 07:47:55', '15510792994', '15510792994');
INSERT INTO `roles` VALUES (3, 'COURSE_MANAGER', '课程管理员', '管理课程信息，对课程、课时、章节进行管理。', '2020-07-20 07:52:04', '2020-07-20 07:52:04', '15510792994', '15510792994');
INSERT INTO `roles` VALUES (4, 'AD_MANAGER', '广告管理员', '管理广告、广告位信息', '2020-07-20 07:55:56', '2020-07-20 07:55:56', '15510792994', '15510792994');
COMMIT;

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `course_id` int(11) DEFAULT '0' COMMENT '课程ID',
  `teacher_name` varchar(255) DEFAULT NULL COMMENT '讲师姓名',
  `position` varchar(100) DEFAULT '' COMMENT '职务',
  `description` text COMMENT '讲师介绍',
  `create_time` datetime NOT NULL COMMENT '记录创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_courseId` (`course_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of teacher
-- ----------------------------
BEGIN;
INSERT INTO `teacher` VALUES (165, 18, '李彬', '讲师', '幽默', '2022-05-14 20:49:20', '2022-05-22 14:30:09', 0);
INSERT INTO `teacher` VALUES (166, 19, '杨', '讲师', '秀', '2022-05-16 00:08:54', '2022-05-22 14:29:59', 0);
INSERT INTO `teacher` VALUES (167, 20, '王中生', '讲师', '优秀的老师', '2022-05-22 11:32:35', '2022-05-22 11:32:55', 0);
INSERT INTO `teacher` VALUES (168, 21, '马昕劼', '讲师', '胖老师', '2022-05-22 11:38:02', '2022-05-22 11:38:02', 0);
INSERT INTO `teacher` VALUES (169, 22, '杨雨佳', '讲师', '讲师', '2022-05-22 11:40:48', '2022-05-22 11:40:48', 0);
INSERT INTO `teacher` VALUES (170, 23, '马伟', '讲师', '马老师', '2022-05-22 11:42:34', '2022-05-22 11:42:34', 0);
INSERT INTO `teacher` VALUES (171, 24, '陈智勇', '讲师', '教学很不错', '2022-05-22 11:45:33', '2022-05-22 11:45:33', 0);
INSERT INTO `teacher` VALUES (172, 25, '郑英姿', '讲师', '', '2022-05-22 11:46:52', '2022-05-22 11:46:52', 0);
INSERT INTO `teacher` VALUES (173, 26, '胡安明', '讲师', '', '2022-05-22 11:48:19', '2022-05-22 11:48:19', 0);
INSERT INTO `teacher` VALUES (174, 27, '张小康', '讲师', '退休老师', '2022-05-22 11:49:45', '2022-05-22 11:49:45', 0);
INSERT INTO `teacher` VALUES (175, 28, '赖劼', '讲师', '', '2022-05-22 11:51:21', '2022-05-22 11:51:21', 0);
INSERT INTO `teacher` VALUES (176, 29, '向军', '讲师', '', '2022-05-22 11:52:23', '2022-05-22 11:52:23', 0);
INSERT INTO `teacher` VALUES (177, 30, '何韦颖', '讲师', '胖班导', '2022-05-22 14:18:29', '2022-05-22 14:18:29', 0);
INSERT INTO `teacher` VALUES (178, 31, '王金恒', '讲师', '有责任心的老师', '2022-05-22 14:19:52', '2022-05-22 14:19:52', 0);
INSERT INTO `teacher` VALUES (179, 32, '曹炜', '讲师', '', '2022-05-22 14:21:34', '2022-05-22 14:21:34', 0);
INSERT INTO `teacher` VALUES (180, 33, '胡安明', '讲师', '', '2022-05-22 14:22:53', '2022-05-22 14:22:53', 0);
INSERT INTO `teacher` VALUES (181, 34, '马昕劼', '讲师', '', '2022-05-22 14:27:22', '2022-05-22 14:27:22', 0);
INSERT INTO `teacher` VALUES (182, 35, '胡安明', '讲师', '', '2022-05-22 14:30:52', '2022-05-22 14:30:52', 0);
INSERT INTO `teacher` VALUES (183, 36, '刘飞生', '讲师', '', '2022-05-22 14:31:55', '2022-05-22 14:31:55', 0);
INSERT INTO `teacher` VALUES (184, 37, '王培颖', '讲师', '', '2022-05-22 14:35:23', '2022-05-22 14:35:23', 0);
INSERT INTO `teacher` VALUES (185, 38, '王剑虹', '讲师', '', '2022-05-22 14:37:03', '2022-05-22 14:37:03', 0);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `name` varchar(255) NOT NULL COMMENT '用户昵称',
  `portrait` varchar(255) DEFAULT NULL COMMENT '用户头像地址',
  `phone` varchar(255) NOT NULL COMMENT '注册手机',
  `password` varchar(255) DEFAULT NULL COMMENT '用户密码（可以为空，支持只用验证码注册、登录）',
  `reg_ip` varchar(255) DEFAULT NULL COMMENT '注册ip',
  `account_non_expired` bit(1) DEFAULT b'1' COMMENT '是否有效用户',
  `credentials_non_expired` bit(1) DEFAULT b'1' COMMENT '账号是否未过期',
  `account_non_locked` bit(1) DEFAULT b'1' COMMENT '是否未锁定',
  `status` varchar(20) NOT NULL DEFAULT 'ENABLE' COMMENT '用户状态：ENABLE能登录，DISABLE不能登录',
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `create_time` datetime NOT NULL COMMENT '注册时间',
  `update_time` datetime NOT NULL COMMENT '记录更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_phone_is_del` (`phone`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100030026 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (100030018, '15011114444', NULL, '15813795039', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2020-07-10 12:17:35', '2020-07-10 12:17:35');
INSERT INTO `user` VALUES (100030019, '15022224444', '', '18201288771', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2020-07-10 12:20:16', '2020-07-10 12:20:16');
INSERT INTO `user` VALUES (100030020, '15033334444', NULL, '18211111111', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2020-07-10 13:57:41', '2022-05-22 14:46:57');
INSERT INTO `user` VALUES (100030022, '15044444444', NULL, '18201288666', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2020-07-13 17:43:52', '2020-07-13 17:43:52');
INSERT INTO `user` VALUES (100030023, '15055554444', NULL, '15014354444', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2022-05-10 17:49:05', '2022-05-10 17:49:05');
INSERT INTO `user` VALUES (100030024, '15066664444', NULL, '15011114444', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2022-05-15 23:36:30', '2022-05-15 23:36:30');
INSERT INTO `user` VALUES (100030025, '15077774444', NULL, '15022224444', '5f0b0c6cf9578ce43f0150925a476faa', NULL, b'1', b'1', b'1', 'ENABLE', b'0', '2022-05-17 12:42:43', '2022-05-17 12:42:43');
COMMIT;

-- ----------------------------
-- Table structure for user_phone_verification_code
-- ----------------------------
DROP TABLE IF EXISTS `user_phone_verification_code`;
CREATE TABLE `user_phone_verification_code` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `phone` varchar(15) DEFAULT '' COMMENT '手机号',
  `verification_code` varchar(15) DEFAULT '' COMMENT '验证码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `isCheck` bit(1) DEFAULT b'0' COMMENT '验证码是否校验过',
  `check_times` int(2) DEFAULT '0' COMMENT '校验次数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `l_phone_verification_code_ind_01` (`phone`,`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33317 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_phone_verification_code
-- ----------------------------
BEGIN;
INSERT INTO `user_phone_verification_code` VALUES (33305, '18201288775', '111111', '2020-07-03 23:59:31', b'1', 80);
INSERT INTO `user_phone_verification_code` VALUES (33306, '008615321919577', '472148', '2020-07-17 16:41:21', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33307, '008615321919577', '254709', '2020-07-17 16:53:02', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33308, '0086', '149696', '2020-07-17 17:33:19', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33309, '0086', '164595', '2020-07-17 18:00:48', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33310, '008615321919577', '994241', '2020-07-17 18:01:27', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33311, '008615321919577', '775431', '2020-07-17 18:04:31', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33312, '008615321919577', '610538', '2020-07-17 18:06:45', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33313, '008615321919577', '317040', '2020-07-17 18:17:05', b'0', 0);
INSERT INTO `user_phone_verification_code` VALUES (33314, '008618201288770', '956444', '2020-07-23 16:18:56', b'1', 2);
INSERT INTO `user_phone_verification_code` VALUES (33315, '18201288771', '029570', '2020-07-23 18:01:20', b'1', 2);
INSERT INTO `user_phone_verification_code` VALUES (33316, '18201288771', '058365', '2020-07-23 19:11:35', b'1', 2);
COMMIT;

-- ----------------------------
-- Table structure for user_role_relation
-- ----------------------------
DROP TABLE IF EXISTS `user_role_relation`;
CREATE TABLE `user_role_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关系id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) NOT NULL COMMENT '创建人',
  `updated_by` varchar(100) NOT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COMMENT='用户和角色关系表';

-- ----------------------------
-- Records of user_role_relation
-- ----------------------------
BEGIN;
INSERT INTO `user_role_relation` VALUES (13, 100030016, 4, '2022-05-11 15:33:23', '2022-05-11 15:33:23', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (14, 100030016, 5, '2022-05-11 15:33:23', '2022-05-11 15:33:23', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (15, 100030016, 6, '2022-05-11 15:33:23', '2022-05-11 15:33:23', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (33, 100030011, 3, '2022-05-19 09:44:43', '2022-05-19 09:44:43', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (47, 100030024, 1, '2022-05-22 14:47:28', '2022-05-22 14:47:28', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (48, 100030024, 2, '2022-05-22 14:47:28', '2022-05-22 14:47:28', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (49, 100030024, 3, '2022-05-22 14:47:28', '2022-05-22 14:47:28', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (50, 100030024, 4, '2022-05-22 14:47:28', '2022-05-22 14:47:28', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (51, 100030025, 2, '2022-05-22 14:47:31', '2022-05-22 14:47:31', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (52, 100030025, 3, '2022-05-22 14:47:31', '2022-05-22 14:47:31', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (53, 100030025, 4, '2022-05-22 14:47:31', '2022-05-22 14:47:31', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (54, 100030023, 4, '2022-05-22 14:47:35', '2022-05-22 14:47:35', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (55, 100030023, 3, '2022-05-22 14:47:35', '2022-05-22 14:47:35', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (56, 100030022, 2, '2022-05-22 14:47:41', '2022-05-22 14:47:41', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (57, 100030022, 3, '2022-05-22 14:47:41', '2022-05-22 14:47:41', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (58, 100030020, 4, '2022-05-22 14:47:49', '2022-05-22 14:47:49', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (59, 100030019, 1, '2022-05-22 14:48:00', '2022-05-22 14:48:00', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (60, 100030018, 1, '2022-05-22 14:48:09', '2022-05-22 14:48:09', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (61, 100030018, 2, '2022-05-22 14:48:09', '2022-05-22 14:48:09', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (62, 100030018, 3, '2022-05-22 14:48:09', '2022-05-22 14:48:09', 'system', 'system');
INSERT INTO `user_role_relation` VALUES (63, 100030018, 4, '2022-05-22 14:48:09', '2022-05-22 14:48:09', 'system', 'system');
COMMIT;

-- ----------------------------
-- Table structure for user_weixin
-- ----------------------------
DROP TABLE IF EXISTS `user_weixin`;
CREATE TABLE `user_weixin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `union_id` varchar(255) NOT NULL DEFAULT '' COMMENT '认证id,微信对应的时unionId',
  `open_id` varchar(255) DEFAULT NULL COMMENT 'openId',
  `nick_name` varchar(255) NOT NULL COMMENT '昵称',
  `portrait` varchar(512) DEFAULT NULL COMMENT '头像',
  `city` varchar(255) DEFAULT NULL COMMENT '城市',
  `sex` int(11) DEFAULT NULL COMMENT '性别, 1-男，2-女',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `oauthId_and_oauthType_unique` (`union_id`,`open_id`,`is_del`) USING BTREE,
  UNIQUE KEY `userId_and_oauthType_unique_index` (`user_id`,`open_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=506562 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of user_weixin
-- ----------------------------
BEGIN;
INSERT INTO `user_weixin` VALUES (506561, 100030019, 'oXEX_svcbl-mCDhWloqlEFNVHgP8', 'oGYgl0u0vZMKVAByQ3hR0i7jpKew', 'leo', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83epKy1c3YeeI5vRqSxqDkaYc9XDuPao1BRLFKGf65SiaRIFqHTpeJg90RfrCXCo7WkicpfsPdKTdNTpA/132', '', 1, '2020-07-23 19:12:21', '2020-07-23 19:12:21', b'0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
